<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateNwYbzGzclybzTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('nw_ybz_gzclybz', function (Blueprint $table) {
            $table->id()->comment('主键ID');
            $table->string('handler')->comment('处理人');
            $table->string('fault_name')->comment('故障名称');
            $table->date('occurred_at')->nullable()->nullable()->comment('发生时间');
            $table->string('business_system_name')->nullable()->comment('业务系统名称');
            $table->string('db_issue_type')->nullable()->comment('数据库问题类型');
            $table->text('cause_of_fault')->nullable()->comment('故障产生原因');
            $table->text('resolution_method')->nullable()->comment('处理方法');
            $table->date('resolution_time')->nullable()->comment('处置时间');
            $table->text('has_business_feedback')->nullable()->comment('业务侧是否有反馈');
            $table->string('resolution_result')->nullable()->comment('处置结果');
            $table->timestamp('business_rectification_time')->nullable()->comment('业务侧反馈的整改时间');
            $table->string('is_repeated')->nullable()->comment('是否重复出现');
            $table->text('remarks')->nullable()->comment('备注');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('nw_ybz_gzclybz');
    }
}
